package com.eduction.service;

import java.sql.SQLException;
import java.util.List;

import com.eduction.modules.system.entity.SchoolItemData;

public interface SchoolItemDataService {

	/**
	 * 查询分项值
	 * @param schoolId
	 * @param itemId
	 * @return
	 * @throws SQLException 
	 */
	public SchoolItemData querySchoolItemData(String schoolId, String itemId,int year) throws SQLException;


	/**
	 * 根据schoolId查询分项值
	 * @param itemId
	 * @param schoolId
	 * @return
	 * @throws SQLException
	 */
	List<SchoolItemData> querySchoolItemDataBySchoolId(String itemId,String schoolId) throws SQLException;

	/**
	 * b保存分项值
	 */
	public void saveSchoolItemData(SchoolItemData s);

	SchoolItemData queryById(String p_id);
	
	public void updateSchoolItemData(SchoolItemData s) throws SQLException;

    List<SchoolItemData> querySchoolItemDataByItemIdAndSchoolId(String itemId, String schoolId,String year) throws SQLException;
}
